# -*- coding: UTF-8 -*-
'''
Created on 2018年3月21日

@author: wqp0010@gmail.com
'''
import pymysql

db = pymysql.connect("192.168.60.54", "root", "admin123", "test")

cursor = db.cursor()

cursor.execute("DROP TABLE IF EXISTS EMPLOYEE")

sql ="""CREATE TABLE EMPLOYEE (
         ID INT NOT NULL AUTO_INCREMENT,
         FIRST_NAME  CHAR(20) NOT NULL,
         LAST_NAME  CHAR(20),
         AGE INT,  
         SEX CHAR(1),
         INCOME FLOAT ,
         PRIMARY KEY (`id`))"""

cursor.execute(sql)

db.close()
